Balance Sheet
This template is a financial report for businesses. It is primarily used to report the financial condition of the firm to the owners. It is also presented to lenders to obtain financing. Please note that "accumulated depreciation" and "doubtful accounts" must be entered as negative numbers. The Retained Earnings figure for each year is calculated, to insure that Assets equal Liabilities plus Equity. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.
Balance Sheet
<-- Enter the date of the balance sheet in cell to the left
(all numbers in $000)
ASSETS Current Assets Cash Accounts receivable (less doubtful accounts) Inventory Temporary investment Prepaid expenses Total Current Assets
LIABILITIES Current Liabilities Accounts payable Short-term notes Current portion of long-term notes Interest payable Taxes payable Accrued payroll Total Current Liabilities
Fixed Assets
Long-term investments Land Buildings (less accumulated depreciation) Plant & equipment (less accumulated depreciation) Furniture & fixtures (less accumulated depreciation) Total Net Fixed Assets
Long-term Liabilities
Mortgage Other long-term liabilities Total Long-term Liabilities
Shareholders' Equity
Capital stock Retained earnings Total Shareholders' Equity
TOTAL ASSETS
TOTAL LIABILITIES & EQUITY